const { DataTypes } = require('sequelize')

const seq = require('../db/seq')

const Goods = require('./goods.model')

const Cart = seq.define('zd_carts', {
  goods_id: {
    type: DataTypes.INTEGER,
    allowNull: false,
    comment: '商品id',
  },
  user_id: {
    type: DataTypes.INTEGER,
    allowNull: false,
    comment: '用户id',
  },
  number: {
    type: DataTypes.INTEGER,
    allowNull: false,
    defaultValue: 1,
    comment: '数量',
  },
  selected: {
    type: DataTypes.BOOLEAN,
    allowNull: false,
    defaultValue: true,
    comment: '是否选中, 0：没选中, 1：选中',
  },
})

// 建表
// Carts.sync({ force: true })

// 关联goods表
Cart.belongsTo(Goods, {
  foreignKey: 'goods_id', // 外键是goods_id，对应zd_goods表里的id
  as: 'goods_info', // 取一个别名
})

module.exports = Cart
